MILES!
THIS SPREADSHEET CAME ABOUT DUE TO THE NEED IN OUR COMPANY TO COMPUTE
A FREIGHT RATE BETWEEN OUR MANUFACTURING FACILITY AND THE DESTINATION
AIRPORT.WE BUILD AIRCRAFT HANGARS SO OUR CUSTOMERS ARE ALWAYS ON AIRPORTS.
THE MATH WAS FOUND IN THE BASIC CODE FOR A PROGRAM CALLED AIRMILES AND FULL
CREDIT IS DUE .
INSERT LATITUDE AND LONGITUDE IN THE FOLLOWING FORM:

N32-41.6 BECOMES 32.416

A VERY GOOD SOURCE OF COORDINATES IS IN A LITTLE BOOK CALLED
AC-U-KWIK .IT IS AN AIRMANS REFERENCE GUIDE AND IS AVAILABLE FROM
402-978-7709.


THE PROGRAM CAN EASILY BE MODIFIED AND LINKED TO OTHER SHEETS TO RETURN 
FREIGHT RATES ECT.

ZIP FILE SHOULD CONTAIN TWO FILES:
MILES.TXT :ASCII DOCUMENTATION
MILES.XLS :EXCEL SPREADSHEET 

FEEL FREE TO MODIFY OR COPY AND FREELY DISTRIBUTE THIS SHE
GREAT CIRCLE MILES

DG=360/(PI()*2)

DAB=SIN(LAT1)*SIN(LAT2)+COS(LAT1)*COS(LAT2)*COS(LONG1-LONG2)

FNACOS=ATAN(SQRT(1-V1*V1)/V1)*DGWHERE V1 
IS RESULT OF VECTOR DAB
DIST IS ABS(FNACOS(DAB))

DIST X 69.133 FOR STATUTE
" X 60.0576 FOR NAUT

AFTER IMPUTING LAT AND LONG IN FORM: 85.254 
DIVIDE EACH BY DG TO GET USABLE FORM I.E LAT1
 HAVE FUN!
VAN THURSTON JR.
404-227-8520
TEK* BUILDING SYSTEMS